package com.ql.dao.sheBeiGuanLi;

import com.ql.pojo.sheBeiGuanLi.SheBeiKuCun;
import org.apache.ibatis.annotations.Param;

import java.util.List;

public interface SBKCMapper {
    //查询所有库存信息
    List<SheBeiKuCun> qryAll(@Param("start")int start,
                             @Param("end")int end,
                             @Param("xzId")String xzId,
                             @Param("zt")String zt,
                             @Param("keshi")int keshi,
                             @Param("mohuName")String mohuName
    )throws Exception;
    //获取总条数
    int qryCount(@Param("xzId")String xzId,
                 @Param("zt")String zt,
                 @Param("keshi")int keshi,
                 @Param("mohuName")String mohuName
    )throws Exception;
    //单个删除
    int del(@Param("sId")int sId) throws Exception;
    //批量删除
    int delBatch(List<Integer> list)throws Exception;
    //根据库存id查看详情
    SheBeiKuCun qryById(@Param("sId")String sId)throws Exception;
    //新增库存信息
    int save(SheBeiKuCun sheBeiKuCun)throws Exception;
    //修改信息
    int modify(SheBeiKuCun sheBeiKuCun)throws Exception;
}
